using System;
using System.Data;
using System.Data.SqlClient;

namespace QUAN_LY_NGAN_HANG_CAU_HOI_TRAC_NGHIEM
{
    public class GiaoVienLinhVucDAL
    {
        private Guid _giaoVien;

        public Guid GiaoVien
        {
            get { return _giaoVien; }
            set { _giaoVien = value; }
        }

        private Guid _linhVuc;
        public Guid LinhVuc
        {
            get { return _linhVuc; }
            set { _linhVuc = value; }
        }

        public static void InsertLinhVucGiaoVien(Guid MaGV, Guid MaLV)
        {
            using (SqlConnection cn = new SqlConnection(Globals.ConnectionString))
            {
                SqlCommand cmd = new SqlCommand("usp_InsertGiaoVienLinhVuc", cn);
                cmd.CommandType = CommandType.StoredProcedure;
                cmd.Parameters.Add("@MaGV", SqlDbType.UniqueIdentifier).Value = MaGV;
                cmd.Parameters.Add("@MaLV", SqlDbType.UniqueIdentifier).Value = MaLV;
                cn.Open();
                cmd.ExecuteNonQuery();
            }
		}
    }
}